Creating the SQL Server database

A SQL Server database is necessary to store GCF/Project Portal collaboration data.

To create the SQL Server database:

1. In SQL Server Management Studio, create a database with a descriptive name, for example, GCFProjectPortal.
2. Navigate to the SqlCmd subfolder of the installation folder that you specified in Installing the GCF processors.
3. Open the file CreateAll.cmd in any text editor and verify that the command line matches your SQL Server computer name and database name.
4. Run the command file to create the tables. Following is an example command line.

sqlcmd -S <ServerName> -E -d GCFProjectPortal -i CreateAll.sql